create external table  jms_ods.tms_city_prescription_config
   (
     id bigint COMMENT '主键',
	region_code int COMMENT '大区编码',
	region_name string COMMENT '大区名称',
	new_agent_code  int COMMENT '新代理区编码',
    new_agent_name string comment '新代理区名称',
    area_code  int COMMENT '区域编码',
    area_name string COMMENT '区域名称',
    agent_code  int COMMENT '原代理区编码',
    agent_name string COMMENT '原代理区名称',
    create_time TIMESTAMP COMMENT '创建时间' ,
	update_time TIMESTAMP COMMENT '修改时间',
	create_name string COMMENT '创建人',
	update_name string COMMENT '修改人'
	)
	COMMENT '城市时效占比配置表'
	PARTITIONED BY (
  `dt` string COMMENT '时间分区(yyyy-MM-dd)')
ROW FORMAT SERDE
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'
STORED AS INPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'
OUTPUTFORMAT
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  '/user/hive/dw/hive/jms_ods.db/external/tms_city_prescription_config'
tblproperties (
        'parquet.column.index.access' = 'true'
);